IF exists(SELECT * FROM dbo.sysobjects WHERE name='oudMail' AND xtype='V') 
BEGIN
	DROP VIEW oudMail
END
GO

create view oudMail
as
select  o.email from oudleerlingen as o
where o.email is not null